<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
require_once("../Scripts/authenticate.php"); //Only users who are logged in can access this page
require_once("../Scripts/DatabaseConnect.php");
require_once("../Scripts/UpdateStocks.php");//Checks if we need to update the database with new market data.

//Check if we need local server or remote server
$con=Remoteconnect();
if($con==null){
	$con=Localconnect();	
}
//Display the last update date and current date and time.
$lastUpdate="";
$result = mysqli_query($con,"SELECT * FROM  `time`");

while($row = mysqli_fetch_array($result)) {
	$lastUpdate=$row['LastUpdate'];

  
}

$date = date('m-d-Y h:i:s a', time());//gets current date and time of server.
echo"Date: $date, Last Update: $lastUpdate";
?>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="EN" lang="EN" dir="ltr">
<head profile="http://gmpg.org/xfn/11">
<title>J&J Free Stock backtesting</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="imagetoolbar" content="no" />
<link rel="stylesheet" href="businesstoday/styles/layout.css" type="text/css" />
</head>
<body id="top">
<div class="wrapper col1">
  <div id="header">
    <img src="../Images/the-top-5-high-volume-trading-stocks-of-the-week_1118_437849_0_14042581_500.jpg" alt="" width="240" height="162" />
    <div id="logo">
      <h1>J&amp;J Free Stock Backtesting    </h1>
    </div>
    <div id="newsletter">
    <div id="login" style="display:block; min-height:50px; min-width:600px;">
      <p><a href="#">Lost your password?</a> <a href="register.php">Register</a>

      </p>
    
      <form action="../Scripts/authenticate.php" method="post" >
      
        <fieldset>
          <legend>NewsLetter</legend>
          <table>
            <tr>
              <td>Name:</td>
              <td><input type="email" name="email" required="required" id="email" /></td>
              <td>Password:</td>
              <td><input type="password" name="password" required="required" id="password" /></td>
              <td><input type="submit" name="news_go" id="news_go" value="Login" /></td>
            </tr>
          </table>
        </fieldset>
      </form>


      </div>
      
      <?php
	  //Wrong password message
      if (isset($_SESSION['msg'])) {
	echo "<p style='color:red'>".$_SESSION['msg']."</p>"; 
	//remove the message since it has been displayed.
	unset($_SESSION['msg']);
	}
	?>
    
   	<?php
	//logout button
    if (isset($_SESSION['msgG'])) {
		echo"<form>";
		echo "<p style='color:green'>".$_SESSION['msgG']."</p>"; 
		echo '<input type="button" name="logout" id="logout" value="Logout" onClick="location.href=\'../Scripts/Logout.php\'"/>'; 
		echo"</form>";
	}
	
?> 
  

    </div>
    <br class="clear" />
  </div>
</div>

<div class="wrapper col2">
  <div id="topbar">
    <div id="topnav">
      <ul>
        <li class="active">
         
              <li><a href="index.php">Home Page</a></li>
              <li id="portfolio" style="display:none"><a href="portfolio.php">Stock Portfolio</a></li>
              <li id="stockMonitoring" style="display:none"><a href="stockMonitoring.php">Stock Monitoring</a></li>
              <li><a href="stockbacktest.php">Stock Backtest</a></li>
              <li><a href="charts.php">Stock Charts</a>
               <ul>
            <li><a href="chartDifShares.php">Stock Prices Comparision Chart</a></li>
            <li><a href="chartIndicators.php">Stock Technical Analysis Chart</a></li>
         
          </ul>
        </li>

        
  </li>      
        
        
      </ul>
    </div>
 <script type="text/javascript">
 //Hides/Shows navigation bar links based on logged in status
	  var check = <?php echo json_encode(isset($_SESSION['email'])); ?>;
	  
	  if(check==true){
		  document.getElementById("login").style.display="none";
		  document.getElementById("portfolio").style.display="block";
		  document.getElementById("stockMonitoring").style.display="block";

	  }else{
		  document.getElementById("login").style.display="block";
		  document.getElementById("stockMonitoring").style.display="none";
		  document.getElementById("portfolio").style.display="none";
		  
	  }
	 
 </script>
        
    <br class="clear" />
  </div>
</div>
<div class="wrapper col3">
  <div id="intro">
    <div class="fl_right"></div>
          <p><a href="PortfolioStats.php">Portfolio Stats</a>&nbsp;&nbsp;&nbsp;<a href="PortfolioTrans.php">Transaction Data</a>&nbsp;&nbsp;&nbsp;<a href="EditData.php">Edit Transaction Data</a></p>
<br class="clear" />
  </div>
</div>
<div class="wrapper col4"></div>
<div class="wrapper col5">
  <div id="container">
    <div id="content">
      <h2>Portfolio</h2>
      <form>
      </form>
     <form id="Add to portfolio" name="addPortfolio" method="post" action="../Scripts/addPortfolioProcess.php">
            <p>
              <label for="textfield2">Add Symbol:</label>
              <?php
			  	
    

			  	$con=Remoteconnect();
				if($con==null){					
					$con=Localconnect();						
				}
				$result = mysqli_query($con,"SELECT * FROM  `company info`");


				echo "<select id='Symbol' name='Symbol'>";

				while($row = mysqli_fetch_array($result)) {
					
    				echo "<option value='$row[Symbol]'>" . $row['Symbol'] . "</option>";

				}
				
				echo "</select>";
				//mysqli_close($con);
				
			  
			  ?>
            </p>
            <table width="200" border="1">
              <tr>
                <td>Type</td>
                <td>Date</td>
                <td>Shares</td>
                <td>Price</td>
                <td>Commission</td>
                <td>Notes</td>
              </tr>
              <tr>
                <td><select id="Type" name="Type">
                  <option value="buy" selected>Buy</option>
                  <option value="sell">Sell</option>
                </select></td>
                <td><input type="date" name="Date" id="Date"></td>
                <td><input type="number" name="Shares" id="Shares"></td>
                <td><input type="number" step="0.01" name="Price" id="Price"></td>
                <td><input type="number" step="0.01" name="Commission" id="Commission"></td>
                <td><input type="text" name="Notes" id="Notes"></td>
              </tr>
            </table>
            <p>&nbsp;&nbsp;</p>
            <p>
              <label for="textfield"></label>
              <label for="textfield3"></label>
              <label for="textfield4"></label>
              <label for="textfield5"></label>
              <label for="textfield6"></label>
              <label for="LinkCash">Link to cash<input type="checkbox" name="LinkCash" value="yes"></label>
            </p>
            <p>
              <input type="submit" name="submit" value="Add to portfolio" />
              </p>
              </form>
            </p>
            <p>&nbsp;</p>
            <p>
              <?php
				
				$Email=$_SESSION['email'];
				$cash=0;
				$result = mysqli_query($con,"SELECT * FROM  `userportfolio cash` WHERE `Email`='$Email'");


				

				while($row = mysqli_fetch_array($result)) {
					
    				if($row['Cash']!=0){
					$cash=$row['Cash'];
					}

				}
				
				echo "<h1>Desposit/Withdraw Cash:</h1><br>";
					echo "Current Cash total:$$cash";
				mysqli_close($con);
			
			
			?>
            </p>
            <p>&nbsp; </p>
           <form id="Add to portfolio" name="addPortfolio" method="post" action="../Scripts/addPortfolioProcess.php">
            <table width="200" border="1">
              <tr>
                <td>Deposit type</td>
                <td>Date</td>
                <td>Amount</td>
                <td>Notes</td>
              </tr>
              <tr>
                <td><select id="DepositType" name="DepositType">
                  <option value="Withdraw" name="Withdraw" selected>Withdraw</option>
                  <option value="Deposit" name="Deposit">Deposit</option>
                </select></td>
                <td><input type="date" name="Date" id="Date"></td>
                <td><input type="number" step="0.01" name="Amount" id="Amount"></td>
                <td><input type="text" name="Notes" id="Notes"></td>
              </tr>
            </table>
            <p>&nbsp;</p>  
          
          

            <input type="submit" name="submit" value="Deposit/Withdraw">
              
                      
          </form>
    </div>
    <br class="clear" />
  </div>
</div>
<div class="wrapper col6"></div>
<div class="wrapper col7">
  <div id="copyright">
    <p class="fl_left">Copyright &copy; 2011 - All Rights Reserved - <a href="#">Domain Name</a></p>
    <p class="fl_right">Template by <a href="http://www.os-templates.com/" title="Free Website Templates">OS Templates</a></p>
    <br class="clear" />
  </div>
</div>
</body>
</html>
